SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018474 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018474 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828326,73759,831408,521490,43216,18130,36220,786287,768870,670515,182062,856144,202228,530119,589763,1030719,524018,367994,34319,104718,674779,498286,348056,571580,207535,315725,614437,242253,799265,690303,704085,151660,429295,470222,864860,814569,607394,680560,385089,1034152,929886,635120,284798,511370,308046,827963,531486,675939,409891,951593,832081,654443,467907,796849,47687,720399,50899,496725,150427,985065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]