SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 373713 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 373713 [ RunTime:0.003747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245738,786001,486263,934410,381063,1034115,893303,291960,782576,378652,221438,657572,66543,770287,900638,22964,868238,948625,41854,918713,842710,49807,154305,355026,816924,816008,81566,152762,842840,2597,492167,1010794,466814,477095,588255,333492,954551,959204,748702,800932,159720,438035,525573,458426,806546,449389,141035,1002052,536596,319159,79821,584972,428600,747246,566590,317948,577187,707543,675408,50804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 373713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 373713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]