SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002380 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002380 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446085,39745,684870,584591,172309,515607,539725,991314,818929,1003384,3094,1012812,643760,687749,914102,381954,621493,946260,719197,428060,967003,713608,406071,498930,806899,382994,181643,780542,873199,448658,971248,503164,876043,724040,896697,649905,243058,902084,971273,601010,253379,96833,640087,164535,565788,40553,273246,737659,187393,17727,364053,396734,988690,903976,214584,12831,494581,840494,743934,306710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]