SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562610 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562610 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162707,98066,643060,1038027,8032,372751,625447,364288,172926,878242,546108,982742,143741,928085,936431,84850,717012,908640,772477,586983,776877,149389,945872,804003,1035883,326381,963095,916626,30960,1021937,274442,146798,834942,273461,874787,531199,811316,578384,620759,452422,331343,1003229,296490,64754,949732,88363,350595,459056,363589,922650,1039061,767483,184487,649740,290110,705339,324133,384554,676920,514310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]