SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330409 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330409 [ RunTime:0.003460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633314,550030,356173,995718,838700,621691,612255,142189,19356,502709,842051,616857,84315,201228,20524,598233,684566,462645,103741,190598,1095,599096,1024249,343499,798998,876812,822749,752914,899156,298214,948981,390317,1008423,571237,577473,243605,877943,709342,676493,367248,314260,421575,406509,1041634,868844,892471,878668,176244,273320,972165,861466,330108,474864,247966,803897,642621,508510,54503,187911,1048707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]