SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318499 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318499 [ RunTime:0.005442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858140,612118,1040132,366892,298442,748987,884379,775073,921796,842952,714356,99291,1036115,830234,268244,679058,548915,1020592,230694,449035,298978,281261,146649,731087,471223,444575,160767,610328,628318,104964,981885,342120,847601,72138,564401,379602,232050,488442,433304,477760,115174,457272,690547,466144,782249,678666,208359,872741,677894,1001701,782568,191145,5521,731693,333220,82494,852314,240721,356797,765432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001698s ]