SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543839 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543839 [ RunTime:0.003122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364191,320270,778550,149782,824847,20193,110193,813787,885876,295394,190778,902194,146402,673737,534521,701769,855114,108363,730324,112674,928186,175722,827315,613434,692795,1034178,594114,305666,28368,252097,428905,1046520,224051,151923,697800,559350,456179,986100,455980,846101,79567,809772,1045720,226598,37733,446391,728189,670411,1021575,623274,1013685,711129,567606,419106,744020,811931,359967,441733,345063,456940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]