SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106283 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106283 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405689,454148,679279,107957,167175,487313,409636,589560,549670,568455,443917,8036,633384,394631,1007371,276420,137194,946951,793670,429971,912137,630616,43942,3326,28913,227558,256722,854854,274598,494144,249062,987520,317396,1019688,733115,375391,569532,1034319,398816,35711,454396,1024158,786469,280970,196405,359981,285884,845404,757659,866031,829792,357487,861361,373267,535869,912911,626992,950023,835762,1012815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]