SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43160 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43160 [ RunTime:0.005400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351014,151576,263996,334964,915862,599437,81034,6043,256835,2570,800420,656496,32495,94976,865108,623232,557139,659922,222361,563844,34430,875070,1011674,1032551,923805,505657,586322,276473,638759,9954,118338,1027882,892168,728644,251600,297973,77602,28847,608476,464131,556059,416923,753583,405145,231499,569478,870817,331663,867614,235943,99444,639461,451339,424640,612426,904707,544360,754002,212783,885442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]