SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577710 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577710 [ RunTime:0.003790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198158,583557,830735,240627,66311,557539,582747,665552,19586,69149,748679,500559,675124,789461,188187,836770,977739,791792,846729,61227,182359,22222,686254,739680,893090,964365,802108,148672,549948,396331,863232,55425,895829,1001089,175375,675681,448162,344799,904676,129742,251735,599342,501061,599576,419918,560644,331072,760248,687305,806606,853186,307462,325878,498020,307338,55855,952088,851996,83461,904847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]