SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138213 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138213 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368224,70098,1016054,488443,942806,276013,214894,778630,1022951,782063,274810,947341,801000,239832,734146,240141,481958,696363,945085,505907,184575,327253,359671,1011025,949216,385966,450107,468175,546983,930544,832909,3050,463966,309857,21775,274766,210946,871807,312292,92747,518157,1000319,271864,71589,307610,332093,297675,823956,744587,858721,584076,423344,602583,430669,94170,750928,980379,817284,251012,98046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]