SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820399 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820399 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333059,554170,164650,122923,10276,459008,1024623,89495,482963,417691,779864,555100,312859,35524,650754,640800,445594,751966,407481,808207,659724,293646,374919,938529,153115,384438,850542,518358,956215,37650,553413,935807,679101,202388,472899,178866,155542,820802,35032,1002638,712617,1008671,634219,151627,743742,491323,407940,301833,848004,834864,761268,307812,645820,60530,622474,541531,712786,41015,240832,327317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005569s ]