SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488411 LIMIT 1 [ RunTime:0.003649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488411 [ RunTime:0.002704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819937,897804,718052,776460,587942,294654,245607,148928,651880,221463,408111,825308,1027999,460877,512134,398780,310762,550557,717642,612929,230218,851852,836602,971051,757128,519390,575491,374265,257023,1030118,156165,531211,182175,980060,533171,650621,67705,57128,200609,370545,548757,126641,481628,188141,917827,784905,749574,897690,63955,230686,310981,158240,848446,117702,528840,893037,817158,175103,226663,641625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]