SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545815 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545815 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281798,803277,358165,655572,1026190,739717,1028542,283851,523355,461340,549931,731786,955776,202805,402701,54803,658159,402843,730098,99458,71818,855403,103148,556844,204847,948966,1040966,563753,208318,219840,31198,713452,270574,68099,125529,662121,266800,1028814,550067,301329,141206,359073,854346,283212,359589,381752,416583,124155,1023654,270038,550253,1012734,103854,139516,257661,984172,74301,997515,406191,626049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]