SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039819 LIMIT 1 [ RunTime:0.000793s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039819 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43389,481173,367911,532991,653386,851104,315032,900580,640839,83060,314550,126865,457454,17426,236854,281051,138628,835951,576596,191311,711230,889612,913037,1021168,873488,400655,441849,603441,206421,828884,1038249,782973,287901,188785,120571,659530,370369,87594,575133,397184,133530,693036,101089,150119,1033830,285864,112010,1025184,896026,662039,1014352,790763,311649,368695,691820,787495,170090,381321,247114,44203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]