SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502698 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502698 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168292,117502,938388,118180,308325,109275,1044336,382250,881073,442170,710888,761473,914040,928699,74670,502472,852482,378464,726262,154571,188238,535432,608141,833021,601862,210470,365752,875905,742284,900337,934956,655791,598339,629645,895565,30728,1024093,410326,525214,749093,8485,530499,306833,93084,410356,563365,715767,886115,1026928,977179,288861,136966,534350,540583,953270,783825,550561,462235,69646,947531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]