SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520311 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520311 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265823,892387,948958,285313,254349,360930,347446,815863,621479,707914,802163,522960,334946,527583,886204,646337,686992,545724,80023,990247,947552,230502,59928,111204,497611,16378,997217,907747,208324,588668,674640,940033,99806,265048,1024097,674260,425525,547756,400410,756355,433457,75814,608774,472554,289906,767479,256348,589540,66445,320381,880431,918344,243204,257045,298798,714560,230501,47282,688116,965235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]