SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803971 LIMIT 1 [ RunTime:0.001116s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803971 [ RunTime:0.006058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541783,239384,154861,415673,683273,98374,390761,958443,996674,691664,748633,479725,499186,165551,606544,946534,756425,1032385,91976,508368,107132,5581,248194,166164,898914,58802,1033732,744028,671026,841465,25217,840739,33116,288817,848651,696815,96812,205091,760124,728076,749269,918377,733539,782391,502941,137338,550734,478511,474828,320005,473648,32546,657915,1035847,289459,424168,137192,933301,856275,754770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004118s ]