SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558018 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558018 [ RunTime:0.002689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493122,129516,431494,900868,938740,419870,357077,952413,844510,184571,193805,333943,287055,136032,953589,71474,526289,8782,279258,546877,1006312,265458,3110,2180,736689,846540,502141,586257,214156,793471,431823,873223,972897,329281,821198,227190,593681,37145,223464,901765,846969,159779,355974,191435,639603,296291,367143,593879,7896,119199,288176,510780,390817,250138,438054,327979,762268,367645,290819,476555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]