SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91809 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91809 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94671,410022,731144,28967,641674,766926,570585,99345,973945,171353,1007866,829688,1006480,496375,120016,30909,270317,586646,166514,529671,818011,1029358,551560,886527,507183,628047,1048530,159602,1032405,616365,134475,204706,1048500,395703,25592,515032,935647,678570,244586,892578,692705,727806,61348,655897,431864,587158,837792,476844,350643,91191,668741,718442,1034584,192994,292330,538550,847597,212219,395371,405658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]