SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150041 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150041 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259416,611518,351625,48491,593603,631566,845317,1037479,789514,759357,356408,933143,670586,1006863,110116,627693,505184,200241,747846,696514,722773,834507,862132,70916,787723,175823,204889,89638,995147,685542,966388,249661,762783,336041,813588,1026219,273517,369947,926972,601357,52371,981150,381673,1046041,847957,401819,798217,51723,646045,307277,710916,31250,334849,518602,574125,807313,118869,349514,960628,1004156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]