SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017149 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017149 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373992,833163,261114,1016846,848718,1041819,1003506,28847,1032385,153252,212956,354244,426214,534813,304076,933469,55884,17283,949931,560093,246314,669316,441421,255764,774323,122496,176359,52775,781788,561001,1025394,603306,1034279,890475,218544,552230,543056,220407,608922,397097,411610,969795,109593,512646,112632,848406,961325,347673,80451,449176,805181,456523,51634,86675,1048376,381211,17397,561634,50616,404114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]