SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190910 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190910 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027296,495286,754649,14017,216516,4409,1042266,322750,922655,482501,215735,866435,168388,320532,187267,642504,859364,155267,136778,62658,585997,809512,357188,862485,533697,63467,183597,477737,842974,34789,335748,1039450,421523,939260,123566,707578,492214,500343,777202,1043847,280685,536220,327045,175793,624613,683118,772725,769625,983457,441366,612200,652632,757033,223918,304411,78791,610529,834733,91918,341156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]