SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349098 LIMIT 1 [ RunTime:0.003026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349098 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39323,547339,147646,403083,785991,265509,477335,648973,220861,834984,368397,665387,527466,398669,1015525,475321,898652,200330,571388,503729,919380,186279,111928,581517,352243,734681,448239,681231,389833,974138,95680,266046,23197,1041559,935518,703679,759200,102573,943070,933679,143505,780683,25964,504499,966517,270694,417980,435393,1026246,847893,252795,29784,624569,416601,1016366,336664,841731,406050,1002081,630503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]