SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419731 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419731 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418801,935701,591197,604069,159615,690838,744705,1004870,361380,86613,444748,1019656,907766,580238,121751,448984,303881,273533,703460,812861,584871,654916,60937,671775,820166,1028623,1045137,979719,188548,806746,951756,252095,904941,284804,478334,922879,569951,853551,937798,167310,1023678,143020,100847,257472,468299,974914,143187,423181,571878,440225,319354,991359,152032,205816,596753,831673,1041232,244366,408923,133797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]