SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409990 LIMIT 1 [ RunTime:0.002220s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409990 [ RunTime:0.001302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980223,1018715,665991,901028,719178,854639,631486,313443,195335,845502,696649,468576,300080,697352,966719,855825,958434,28942,82657,191995,13769,935374,156013,410836,469240,360968,229335,714813,658022,582087,63505,969824,363695,982540,866449,89542,177723,846424,880750,679110,344418,696276,762406,952611,863089,231790,495468,328500,564190,621765,123899,675288,470249,191377,150922,453739,872068,314160,106144,507968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003235s ]