SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566193 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566193 [ RunTime:0.004299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49935,416522,24954,546733,537492,59064,513668,144485,852753,483389,289653,912513,803264,204022,136260,965140,351187,1040063,548177,1039221,479666,401075,141068,341425,4023,461622,537267,290640,343106,62182,1021307,979859,194425,222007,115528,230733,963076,501731,293507,189677,286089,48288,128669,421215,722463,922622,403270,578891,87273,121318,729184,770105,593586,932447,847542,969861,856768,120401,592707,351912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003929s ]