SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501050 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501050 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246042,206003,430414,819579,114678,536130,424900,719165,791488,635220,634907,839135,20228,910933,646445,465750,587644,87997,596859,204651,711215,882087,1026606,809167,707824,665030,478978,332816,180267,449346,477951,361818,453506,580144,116879,749193,1007379,130060,149968,476609,668123,562332,307106,61075,112888,45269,634965,316343,702793,112509,283199,254762,604037,638023,200827,151068,395804,1008376,206103,553124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]