SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281046 LIMIT 1 [ RunTime:0.001304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281046 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682068,65487,387391,40985,470349,386511,487589,692841,864634,243759,130899,20103,918795,593785,389160,510087,615635,569129,214518,381542,219253,1039202,900644,743958,281684,630819,393513,371806,333764,5918,208849,703342,652657,320138,356948,859225,17094,1044687,42094,790633,892373,301102,375421,736538,183605,891523,747856,191371,125919,77319,1016738,960948,333243,953910,75288,426904,381513,527172,150191,1031683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001578s ]