SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020053 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020053 [ RunTime:0.005277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992527,346646,428487,430099,379421,800383,386351,644035,169090,263964,619110,1001557,837973,364870,44008,490512,953673,504033,214005,654309,733978,103761,56422,299908,352427,981712,233779,856783,633267,680373,436899,958206,114912,313800,111476,21353,827983,705398,867276,827649,135333,1024429,173694,913547,371940,693934,514497,432493,907276,212561,70420,1001993,746940,1000763,257201,336048,196221,486967,619239,1048729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]