SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007810 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007810 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776183,834836,414390,748262,477478,1019239,928058,423259,175180,53256,31740,867153,531789,580450,670993,677358,819647,260228,439660,354032,686246,964083,757848,648131,682484,632083,395822,578034,611525,320077,285761,277389,111793,110767,115204,141022,809343,16613,1042858,56864,753595,608025,891982,614883,667040,902064,570380,703882,950672,476693,741422,790627,473252,696714,830460,527292,443468,990497,944828,414543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]