SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514644 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514644 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392599,24711,541657,436966,393683,990354,694453,384682,878077,845464,1036379,244232,965551,699569,485358,1008997,275207,709407,385908,19225,864154,456054,834797,1024760,838252,627197,352107,608532,56207,94415,300140,265343,98301,514349,832906,148766,750588,590199,1021326,47797,17570,688664,420404,546576,324932,120531,851804,115195,374455,260917,240650,615137,19675,917533,786746,39475,171290,589543,996638,841521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]