SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409129 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409129 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626687,919681,706733,815647,1025780,215116,961366,444483,262131,86675,937023,1043628,402314,712848,593092,395318,407236,250267,579306,724195,17074,38109,458689,758188,576697,263512,581061,107251,45151,940344,441503,121730,653283,393964,1007381,272730,602714,723579,254220,115862,298241,963222,38400,339834,230525,904773,1009929,546575,612147,768963,270431,441276,590563,773848,654491,123645,458741,439504,628722,28345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]