SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44113 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44113 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344871,378918,479804,782195,993061,936878,247237,85876,178963,822356,397754,355094,328847,949694,846277,138707,720837,513345,199786,651360,954418,832212,23814,643452,493478,46835,43457,889301,853214,928887,57282,926705,787447,531324,502480,678539,861505,410112,789611,648724,541787,721102,759177,665482,519154,437427,217537,98414,165484,665952,794077,143727,405230,859177,659879,99998,790257,712900,355599,889178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]