SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506415 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506415 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582919,184013,580944,999075,14228,683258,33685,581310,481527,77948,507587,1020633,137232,153561,477065,101261,886657,760651,903447,1018878,64663,653542,553846,1046192,954569,251394,360040,375809,647871,767552,921972,645961,717534,611861,182632,1300,942494,431190,611254,374161,50020,422593,673081,711320,817554,811291,15456,970103,492669,64906,857822,548744,967444,791778,63673,797572,24273,815078,23110,755472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]