SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416840 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416840 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263023,596048,113185,669309,760220,176081,864797,235023,219007,935254,565761,710698,720677,384552,564409,368644,334015,364225,223450,454261,961417,318965,693085,698163,118140,869054,395196,398874,818132,328182,783811,620568,648279,381262,483153,813385,53124,466117,651354,523781,351079,500243,121204,418812,493925,404343,222603,449764,102056,1037692,694118,914474,154050,892801,966704,1009555,795885,634653,82756,521749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]