SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981400 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981400 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892813,593674,596291,87814,33203,455716,864668,87710,165655,792704,900810,766283,912938,545695,735229,179381,90846,196133,240983,219312,126920,439829,210033,184228,129847,626405,69697,71066,116718,721459,678743,1036764,207888,837332,44864,813290,406596,1040372,330031,786196,442628,371812,198261,260473,49400,965034,509128,58902,499379,899737,270769,583645,113717,1024763,269583,730336,875154,298232,551342,583774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]