SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017796 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017796 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26344,142079,450737,937263,703943,51520,567230,994450,477256,764225,40949,863487,707104,882380,322504,389849,193573,171968,651626,707180,514100,600354,910852,212334,155819,920431,609218,779683,520183,160388,1025879,627758,782465,98122,756448,690854,388872,924923,877380,844389,849612,495117,335718,444811,127593,216009,246094,560193,609739,309974,527384,166809,150173,483697,301904,332813,185880,734241,1000601,65898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]