SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200976 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200976 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814038,678144,404406,920068,967895,833574,342805,246517,439980,882405,157880,591315,133368,832656,257530,930676,823333,964008,65415,48253,59087,563301,603116,387822,263214,676240,227242,207472,293681,29220,935299,379992,107822,175939,938028,197532,441710,788575,206325,553590,219760,20486,695739,24301,171170,1024369,48161,733157,601003,162672,301389,784507,656437,859106,293565,276924,3902,768648,353935,368077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]