SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009043 LIMIT 1 [ RunTime:0.002333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009043 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684486,775548,21418,789828,975584,707068,201827,893027,149047,322078,111391,461017,391413,865573,816567,451885,844663,529466,709567,167480,786243,404408,799685,1014645,381413,1009748,985754,922292,753139,415428,1038551,616250,515136,782406,586634,443082,252677,617267,549587,646938,540669,188726,759110,554494,850745,471609,255782,582246,526702,683724,838223,998040,924481,76487,226861,386044,718212,466549,1003025,981842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]