SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008904 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008904 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802346,438197,868330,742334,892093,562925,298703,487102,313223,148860,445528,733869,596525,120103,100108,260623,588791,969770,424734,891497,843041,78728,730659,313910,44663,800438,872041,628437,617349,894408,813280,368375,692493,987479,208517,751782,317010,560452,613434,9690,645809,202749,800095,338917,942621,906885,836405,330140,852420,243968,871374,626044,889542,336878,898853,898514,494376,1033866,677748,699693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]