SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514401 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514401 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043196,880602,427556,915184,553965,412679,179692,880782,647718,737776,678487,587259,266391,1011572,865045,1033168,544613,252340,947084,442475,949428,459059,994870,876873,957433,830058,67593,700549,524989,638747,997710,357254,700563,496391,486916,314977,965083,343089,540905,429532,86835,37599,117883,152367,643588,46936,126454,388993,1023918,652647,546584,161964,183885,187542,885638,332092,453006,865339,999346,884864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]