SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291676 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291676 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837221,490974,36135,834094,223444,630112,1048381,50607,929348,310173,48306,377387,225007,394816,404650,550120,609592,446858,464232,973290,65655,1026359,810439,1197,344573,52382,426167,478034,435381,120029,461011,309528,371633,316011,677058,472253,274960,412582,384085,969916,916093,122338,376974,609792,945609,600938,66234,712578,240660,775775,1033832,688899,748995,581865,303686,260361,1019238,796572,91354,25833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]