SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410031 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410031 [ RunTime:0.002585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46214,235357,698280,676073,515991,343682,394020,313316,636029,29757,234587,844727,700460,1014370,606067,989053,449922,761400,650234,817303,843275,135334,649182,681936,279726,37463,985452,1029006,81645,897243,723819,180277,599398,943118,1024496,285119,279929,88250,36318,789351,1015990,991465,243858,456859,880451,635980,592994,176640,1010966,483631,387444,206249,829181,64310,591827,836645,481729,891584,30944,263932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002088s ]