SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986411 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986411 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430979,770162,2515,231888,771823,173352,738884,214080,475877,364089,667923,302568,262622,322839,757037,269750,553146,237157,270580,488810,535373,922384,306039,169564,637118,971949,423514,500894,314370,823917,528076,62054,1002017,451256,118,831073,814191,213359,388072,361019,370655,859161,281199,366203,449622,696529,483044,337332,883293,664968,799616,936670,844344,862510,357050,835920,602136,534558,697182,441820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]