SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260922 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260922 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233160,407555,936938,121144,95161,498553,481219,749534,964089,614543,116229,22532,100309,115180,462505,563128,952492,27941,936228,1002316,530325,429112,707536,810715,1014184,393997,246178,95220,49697,314968,42087,33623,390070,295567,928213,473560,699580,851642,805651,747369,104549,656293,9517,883553,108588,111295,1039464,355017,320754,355223,1365,274680,40512,347660,742589,149251,146653,723954,597374,898367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]