SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804986 LIMIT 1 [ RunTime:0.000853s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804986 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623074,513563,988432,6681,2616,584089,594754,792931,511279,397190,939612,718929,472390,889965,507100,533003,1009412,189538,188115,136480,1010924,218190,793454,482876,620728,651215,512990,146958,196489,54142,417045,853867,725408,219864,113845,336035,738693,83021,69843,252488,743122,744248,150780,495446,181485,551252,115988,401335,612822,482243,211988,384004,446371,956754,174835,627813,920099,1016677,694739,767396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]