SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731022 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731022 [ RunTime:0.003746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653112,324431,609734,356120,988537,731303,743127,411703,857165,462599,508033,951093,1022478,65822,336758,622902,693066,674319,19140,380995,1017015,758989,499940,642442,762737,925338,886929,470239,73924,268006,395414,267484,23002,438393,782685,157008,964371,503851,200434,33526,202068,979100,610335,269206,926813,491193,289746,287098,1027355,552163,682610,682422,887672,189759,578900,548514,260676,376031,900586,527446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]