SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595796 LIMIT 1 [ RunTime:0.001204s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595796 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821260,897626,906046,231720,1038830,174483,31234,490232,527291,623094,580499,270599,17508,1044718,786406,9592,418688,900880,781331,678450,56995,386447,28557,236285,981647,120592,237249,179642,447015,534030,734580,137412,710964,121949,421655,587208,564538,292679,713459,349755,164555,974189,121822,986041,587853,377796,860061,166472,537614,113569,552605,105586,1040627,418189,415728,379298,1004181,970915,806807,609707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001208s ]