SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468843 LIMIT 1 [ RunTime:0.001509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468843 [ RunTime:0.005124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66907,720800,165118,795131,294351,106785,585940,962579,1008079,334736,639023,639231,825963,104857,873124,555119,261097,44583,445156,766311,841790,299404,502214,731753,654598,292767,334917,784979,829408,521897,697084,180238,81516,746198,73696,992685,729096,266148,992346,978959,535548,348103,119857,309719,226492,636484,132200,706446,108822,788255,362179,89701,831318,361448,597374,783032,658874,1018649,277014,361635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]