SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563560 LIMIT 1 [ RunTime:0.003186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563560 [ RunTime:0.002492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255346,435839,684996,210003,326737,197519,267928,31287,171413,639487,748955,742732,962779,148392,411319,871322,654535,219597,172357,772806,799356,741891,400033,540071,60388,956435,703749,237856,171227,484747,855922,711579,1033502,203249,299849,1027643,783421,191555,602896,112446,783517,915855,710097,115114,723610,822303,496559,623913,288752,759496,832717,768727,1044352,276982,979160,490322,44680,518981,651568,70412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]