SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595109 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595109 [ RunTime:0.002839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486394,139633,827559,108213,610621,182901,964086,351431,406459,611860,614481,306744,657368,841263,486466,833552,1000202,208042,573162,101334,325069,234918,989154,776879,102889,974939,502910,120099,853085,651060,307224,435739,697381,919152,158885,246580,419197,133132,250906,986984,375452,83294,216080,449360,808295,308423,862455,491430,26398,320672,666914,291378,755410,592504,1038189,38026,161603,541700,677655,938498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]