SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012439 LIMIT 1 [ RunTime:0.001239s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012439 [ RunTime:0.003087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365801,170800,879956,243950,389187,458366,208823,750781,737356,123051,554369,401631,549361,957551,489304,736091,926791,619170,283406,511195,137136,433539,871865,387185,394091,907521,392748,691797,697560,661026,847848,900011,768254,121691,875092,93060,780839,994310,431412,1021575,997184,685898,435503,985834,165628,312864,1046297,902351,9476,291864,1035782,594942,377808,569482,266660,120221,1008567,619740,278375,602093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]