SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396680 LIMIT 1 [ RunTime:0.002079s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396680 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988214,904134,784657,108856,1950,862523,128604,271031,168874,526831,969342,589335,806936,346500,299484,349830,657823,956510,464353,709786,505917,112110,968504,823605,1027248,788612,170212,1045457,765672,544860,889163,652656,48625,630589,619014,865723,502388,4992,687756,630236,843117,175795,913574,934221,643331,691233,949306,851767,264839,652061,524909,317615,136261,174718,709657,1030975,1033901,731819,448186,157716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]