SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445648 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445648 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000099,236310,288680,973157,163714,592688,1033106,23188,755341,483572,786406,299403,152842,124050,683095,372181,878149,496933,103432,133097,817206,715837,401776,1038222,1024396,600627,135203,145902,1045793,102855,63391,114780,188818,1022068,151826,216928,490441,697867,661682,4155,60659,596129,897918,425215,565401,32250,727203,299485,33140,673117,716512,1009226,1037088,80184,1042566,40466,315917,199676,742908,670798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]