SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345694 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345694 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492206,109686,739934,788348,551154,898302,517916,395782,624085,402310,209343,555026,886714,576797,245063,577009,398797,268709,882182,930010,829971,962727,680678,1036199,509049,557042,815490,339630,317287,390208,935212,195117,739319,961620,233436,117611,170135,566232,317185,45021,762198,771140,953689,191448,898445,689199,124897,496378,156093,500323,697446,658916,776548,1015320,76985,580457,252129,497865,480904,764910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]