SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340797 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340797 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118752,547392,153789,24276,915068,1024065,614349,318827,40004,330131,864051,365683,323077,195360,176664,862911,438791,230488,806651,192257,81783,244641,733311,109578,628167,13209,364422,91357,122622,1038585,769130,188336,202793,570765,86005,68692,61138,725752,201079,227704,210156,660313,878692,298081,452164,170357,514261,636978,817724,132877,877864,554508,70913,322608,516321,55187,561304,896917,10800,219598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]