SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033470 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033470 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6449,537510,314000,593814,247215,67376,598576,707968,782159,634814,318948,407156,538339,858958,379061,290359,402246,259239,751017,484356,399835,315054,1035179,848359,164748,848353,136405,872978,153194,297190,588799,38151,946369,740951,862186,917315,701670,519379,927374,484818,338953,788780,966355,383821,143909,310464,513198,697213,425370,149,293634,188724,539015,373726,395609,773997,572770,637507,16665,655512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]