SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974014 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974014 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510629,151908,709406,716303,331168,245546,1028988,734751,718081,611827,1045797,795588,638420,981954,433460,1046562,87006,197893,368946,534446,507471,833033,94670,408591,940457,198750,511675,1693,1021809,481342,78996,458885,56832,634853,502440,637987,1032510,505183,884231,159850,396339,84358,770712,189640,336820,224146,34575,495383,123419,68286,2106,791298,1601,913782,184250,354120,787329,247489,538016,695424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]