SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501612 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501612 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959603,87818,630601,466500,246521,394260,388455,694824,324875,675766,406988,401339,396453,988036,258543,131107,653453,604781,461225,140883,692229,237794,645410,22102,800052,710923,419283,547810,1022091,863982,565396,334381,807298,936429,1008178,67567,1025294,425067,314289,459604,497099,366996,865885,1000557,744070,130386,924990,709378,570637,970381,742110,922343,531264,669217,807020,831085,663286,618188,648712,1006126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]