SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142161 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142161 [ RunTime:0.003545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193961,489112,589829,411173,136425,315824,930643,254294,402003,964714,196304,951377,181722,1015964,112739,39056,566501,127435,135807,745125,292987,197403,377492,528113,637476,911383,796835,856210,394536,428683,26060,831281,812192,697060,386370,386901,92239,789541,494134,169145,490667,860731,887104,338204,27810,47300,474769,818498,417956,955625,32867,380423,390949,70411,93783,518434,60223,794985,539884,152308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]