SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024857 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024857 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613203,443680,765488,181174,737741,738026,385778,317916,783427,359042,256632,287423,149606,954166,489692,1006109,130343,711737,739317,235228,14563,477807,303844,305598,167581,639142,791281,105373,949683,177339,676237,269875,394709,800703,795701,656889,970891,734240,318149,1001824,393651,782461,248013,964008,271676,490322,211207,961372,428411,1009514,746486,132549,710820,625399,17255,552457,859743,568262,619979,517985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]