SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801704 LIMIT 1 [ RunTime:0.000780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801704 [ RunTime:0.002520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4669,842245,186924,446475,143589,252480,111613,186028,788608,473239,612158,261739,26651,246638,636763,635414,678737,1017670,955364,607502,527581,993296,651076,664109,976057,233413,789844,548243,311160,129929,892139,172622,451576,265346,283973,335784,58940,98673,620379,629950,295361,226453,913612,376364,1040621,212852,725072,280492,522483,446036,704447,17638,870811,394651,617880,433441,775402,59030,252194,360843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]